{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["June15nc"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"June15nc","index":0,"n_rows":40,"n_cols":38,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,33,7,33],[6,34,7,34],[0,0,0,32]]}
["June 15 Non Calculator"]
[null,"q1a","q1b","q2a","q2b","q3","q4","q5","q6","q7","q8a","q8b","q8c","q9","q10","q11a","q11b","q12","q13","q14","q15a","q15b","q16","q17","q18","q19a","q19b","q20","q21","q22a","q22b and c","q23","q24"]
[null,"Stemand Leaf","Change to a percentage without a calculator","Substitution","Solving Equations","Questionnaires","Percentages","Volume of a Prism","Scattergraphs","Mixed Transformations","Collecting Like Terms","Index Notation","Expanding and Factorising","Worded LCM Questions","Area of Compound Shapes","Probability","Multiply and divide by numbers between 0 and 1","Angles in Parallel Lines","Pythagoras' Theorem","Compound Measures","Coordinates","A GRADE  Y=MX+ C QUESTIONS","Cumulative Frequency","Angles in Polygons","Inequalities Regions","Proof","Solving Quadratics by Factorisation","More Difficult Rearranging Formulae","Recurring Decimals","Fractional & Negative Indices","Surds","Spheres and Cones","Transformations of Functions"]
["Max Mark",3,2,1,2,2,5,3,3,4,2,1,2,3,5,2,3,4,5,3,2,3,6,4,4,3,3,4,3,1,3,5,4]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B4","v":0.45238095238095238},0.7142857142857143,1.25,0.8571428571428571,0.8928571428571429,0.31428571428571428,0.47619047619047622,0.4285714285714286,0.32142857142857145,0.6071428571428571,1.3928571428571428,0.5892857142857143,0.54761904761904756,0.25714285714285717,0.5892857142857143,0.58333333333333337,0.375,0.27142857142857146,0.46428571428571425,0.8571428571428571,0.48809523809523808,0.25,0.39285714285714285,0.4017857142857143,0.46428571428571425,{"$f":"AVERAGE(AA9:AA40)/AA4","v":0.39285714285714285},0.35714285714285715,0.5357142857142857,1.7857142857142858,0.5357142857142857,0.3,0.4017857142857143]
["Standard Deviation",{"$f":"IF(COUNT(B9:B36)<2,\"\",STDEV(B9:B40)/B4)","v":0.32978713316925762},0.53452248382484879,0.92796072713833699,0.44839513942303277,0.45860381629186237,0.21380899352993951,0.31983240761285531,0.26999684279731373,0.19072404509044313,0.49734746139343805,0.9940297973880049,0.43148261688884831,0.28994515891683087,0.20262823361565649,0.51014833406698756,0.30932024237944566,0.22047927592204922,0.19023794624226836,0.30549542457877427,0.52453052831296199,0.33311280182832442,0.15382636783181622,0.2757865135538739,0.23901113520361925,0.31868151360482566,{"$f":"IF(COUNT(AA9:AA36)<2,\"\",STDEV(AA9:AA40)/AA4)","v":0.27297434161777517},0.24933774718103185,0.33134326579600165,0.95673607402664351,0.35531572599331152,0.22771001702132443,0.22912156843408069]
[null,"q1a","q1b","q2a","q2b","q3","q4","q5","q6","q7","q8a","q8b","q8c","q9","q10","q11a","q11b","q12","q13","q14","q15a","q15b","q16","q17","q18","q19a","q19b","q20","q21","q22a","q22b and c","q23","q24","Total Marks","Grade",null,"NEED T CHANGE"]
["Name"]
["Sample student 1",{"$f":"ROUND(RAND()*$B$4,0)","v":1},1,2,3,3,2,3,1,1,2,1,0,2,2,2,1,{"$f":"ROUND(RAND()*$B$4,0)","v":1},2,0,1,2,1,2,1,1,1,1,3,1,3,1,1,{"$f":"IF(AB9=\"\",\"\",SUM(B9:AG9))","v":49},{"$f":"IF(AH9=\"\",\"\",VLOOKUP(AH9,$AK$13:$AL$34,2))","v":"B3"}]
["Sample student 2",2,1,3,3,2,2,1,2,1,0,1,1,2,2,3,1,1,1,3,0,2,3,2,1,0,2,1,2,1,1,0,2,{"$f":"IF(AB10=\"\",\"\",SUM(B10:AG10))","v":49},{"$f":"IF(AH10=\"\",\"\",VLOOKUP(AH10,$AK$13:$AL$34,2))","v":"B3"},null,"Grade Boundaries"]
["Sample student 3",3,3,0,2,2,1,1,2,1,3,1,2,2,0,1,3,2,2,2,1,2,1,0,2,3,1,1,3,2,1,1,3,54,"B2"]
["Sample student 4",2,2,2,3,2,3,2,1,0,2,1,2,1,1,1,3,3,1,1,0,1,2,3,0,0,1,1,1,3,1,2,0,48,"B3",null,"Non- Calc"]
["Sample student 5",0,0,1,1,0,1,1,2,2,1,1,0,2,2,3,2,2,2,0,1,3,2,2,3,1,1,1,1,3,3,1,1,46,"C1",null,0,"F3"]
["Sample student 6",1,2,2,0,2,0,2,0,1,2,0,0,0,0,0,0,1,1,2,3,0,0,1,3,1,1,1,2,2,1,1,0,32,"D1",null,0,"F2"]
["Sample student 7",1,1,1,2,1,3,2,1,2,0,1,1,2,2,3,2,2,0,1,3,1,2,2,2,2,0,2,2,2,3,2,0,51,"B3",null,0,"F1"]
["Sample student 8",3,0,3,1,3,3,0,1,1,2,3,1,0,3,0,2,2,1,3,3,2,2,1,3,1,1,2,0,1,1,1,3,53,"B2",null,0,"E3"]
["Sample student 9",1,3,1,2,1,2,2,1,2,1,1,0,2,0,2,1,2,2,1,2,2,3,0,1,2,1,3,2,0,2,1,2,48,"B3",null,6,"E2"]
["Sample student 10",0,3,1,1,3,2,1,1,2,3,1,3,2,0,1,1,0,3,2,3,1,0,1,2,1,2,2,3,1,3,0,2,51,"B3",null,12,"E1"]
["Sample student 11",2,3,2,1,1,1,0,0,1,0,2,2,2,2,0,3,1,1,3,3,1,1,1,1,1,2,1,2,2,2,0,2,46,"C1",null,18,"D3"]
["Sample student 12",1,0,1,2,3,1,2,1,2,3,3,1,1,0,2,1,1,2,2,1,0,2,0,0,2,3,3,3,1,3,2,1,50,"B3",null,23,"D2"]
["Sample student 13",0,0,1,1,1,3,0,1,2,0,1,1,2,2,1,3,0,3,2,2,1,1,3,1,0,1,3,0,3,0,1,2,42,"C2",null,28,"D1"]
["Sample student 14",2,3,2,2,2,1,1,1,0,1,3,2,3,2,0,1,2,2,0,3,1,1,3,1,3,0,3,1,3,1,3,2,55,"B2",null,33,"C3"]
["Sample student 15",0,0,0,2,0,3,2,0,1,2,2,1,1,1,1,1,2,1,2,1,1,1,1,1,0,2,0,2,3,1,1,1,37,"C3",null,38,"C2"]
["Sample student 16",2,1,2,1,1,1,3,2,2,1,2,3,2,1,0,{"$f":"ROUND(RAND()*$B$4,0)","v":2},0,1,1,2,0,3,0,2,2,2,2,1,2,1,0,0,45,"C1",null,43,"C1"]
["Sample student 17",{"$f":"ROUND(RAND()*$B$4,0)","v":2},1,1,3,2,1,0,1,1,0,2,2,2,2,1,2,2,1,1,2,3,1,3,3,3,1,0,{"$f":"ROUND(RAND()*$B$4,0)","v":2},1,3,3,2,54,"B2",null,48,"B3"]
["Sample student 18",1,1,0,1,2,2,2,1,1,2,0,1,2,1,1,3,2,0,2,0,1,3,1,2,1,0,0,0,3,2,3,3,44,"C1",null,53,"B2"]
["Sample student 19",1,2,0,3,2,3,2,2,2,1,2,1,1,0,3,2,1,2,1,1,1,3,1,1,2,2,1,2,3,0,3,1,52,"B3",null,58,"B1"]
["Sample student 20",1,1,2,1,3,0,1,2,0,1,2,1,3,2,1,2,3,2,1,1,3,2,3,2,2,1,1,2,2,1,0,2,51,"B3",null,64,"A3"]
["Sample student 21",3,2,1,2,1,2,0,0,2,2,1,1,1,1,1,2,0,1,1,2,3,1,0,2,2,2,0,2,1,0,1,1,41,"C2",null,69,"A2"]
["Sample student 22",3,0,1,2,2,1,3,1,2,1,0,1,2,0,0,2,3,2,0,1,3,1,2,1,1,1,3,3,2,2,3,2,51,"B3",null,74,"A1"]
["Sample student 23",2,1,0,0,3,0,2,3,0,1,0,0,3,3,2,0,1,3,1,2,1,2,3,0,3,0,0,1,2,2,3,3,47,"C1",null,79," A*3"]
["Sample student 24",0,2,2,2,3,1,2,3,1,0,0,2,1,3,1,2,1,0,0,3,2,1,3,3,1,2,1,2,0,0,2,2,48,"B3",null,86,"A*2"]
["Sample student 25",1,1,2,2,1,0,1,1,2,1,3,1,3,2,0,0,1,0,2,2,2,1,1,1,2,2,2,2,3,1,3,2,48,"B3",null,93.333333333333329,"A*1"]
["Sample student 26",0,3,2,3,1,0,2,1,2,2,1,2,1,0,1,3,2,2,2,2,0,0,3,3,0,0,2,1,1,1,1,1,45,"C1",null,100,"A*1"]
["Sample student 27",1,2,0,1,2,3,0,2,2,0,3,0,1,1,0,2,2,0,1,0,0,1,1,1,1,1,1,0,1,3,3,2,38,"C2"]
["Sample student 28",{"$f":"ROUND(RAND()*$B$4,0)","v":2},{"$f":"ROUND(RAND()*$B$4,0)","v":1},0,1,1,2,2,2,0,0,1,1,0,1,2,2,2,0,2,3,2,1,1,2,1,0,2,0,1,3,0,2,40,"C2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]